﻿<!DOCTYPE html>
<html>
	<head>
		<title>Pivot Table tab</title>
		<meta charset="utf-8" />
        <meta name="description" content="Introducing the Spreadsheet Editor user interface - Pivot Table tab" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
        <div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
            <h1>Pivot Table tab</h1>
            <p>The <b>Pivot Table</b> tab in the <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> allows <a href="../UsageInstructions/PivotTables.htm" onclick="onhyperlinkclick(this)">creating and editing</a> pivot tables.</p>
            <p>The corresponding window of the Online Spreadsheet Editor:</p>
            <p><img alt="Pivot Table tab" src="../images/interface/pivottabletab.png" /></p>
            <p>The corresponding window of the Desktop Spreadsheet Editor:</p>
            <p><img alt="Pivot Table tab" src="../images/interface/desktop_pivottabletab.png" /></p>
            <p>Using this tab, you can:</p>
            <ul>
                <li>create a new pivot table,</li>
                <li>choose the necessary layout for your pivot table,</li>
                <li>update the pivot table if you change the data in your source data set,</li>
                <li>select an entire pivot table with a single click,</li>
                <li>expand or collapse fields to show/hide the details for the pivot table items,</li>
                <li>highlight certain rows/columns by applying a specific formatting style to them,</li>
                <li>choose one of the predefined tables styles.</li>
            </ul>
        </div>
	</body>
</html>
